-
Publication, Ho! (tags #writing #SQLServer #Database)
As these things happen, I've gotten another technical article published over at SQLServerCentral.com. It's called The ABCs of Database Creation and is a free read (though it does require a registration at SSC, which is also free). This is intended to be the first in a series of ABC articles discussing the how-to of database design in Microsoft SQL ( Read more... ) -
Lessons We Learn from Other People's Blogs (#sqlserver #wit #employment)
When I come into work, I double-check all my SQL databases and jobs, fix any failures, then catch up on emails and respond to my customers. After all this, I take a few minutes to catch up on my SQLServerCentral notifications and newsletters, and any other interesting professional newsletters I have coming to my inbox. I always learn something new ( Read more... ) -
SQL Saturdays - The Fake DBA Job (tags #SQLServer #dbadmin #jobs #employment)
Originally published at Ramblings from the Flip Side (Site under construction). You can comment here or there.
In today’s economy, job hunting is difficult at best. Things are so bad that people unable to find employment after a year plus of searching have stopped looking. This behavior, in turn, skews the federal unemployment ( Read more... ) -
Shhh, Don’t tell the boss (tags #sqlserver #dbadmin #employment)
Originally published at Ramblings from the Flip Side (Site under construction). You can comment here or there.
It’s early in the morning (or late at night) when Vital Process A fails. Maybe it errors out. Maybe it didn’t start in the first place. Regardless of the reason, there’s only one thing you can do. Fix it quickly. Fix it ( Read more... ) -
SQL Saturdays - Fun SQL Facts (tags #SQLServer #dbadmin)
Originally published at Ramblings from the Flip Side (Site under construction). You can comment here or there.
Occasionally I make little notes, fun SQL facts, for myself about things I recently learned about SQL Server. Here are the most recent, mostly restore related.
- A stored procedure cannot be created if it references a database ( Read more... )
-
SQL Saturday - Sexism in the Workplace? (tags #sqlserver #wit #sexism)
Originally published at Ramblings from the Flip Side (Site under construction). You can comment here or there.
I haven’t posted a SQL Saturday post in a while because I’ve had a lot going on, not the least of which is working extra weekend hours. Also, Steve Jones over at SQLServerCentral.com wants me to write more articles for him, ( Read more... ) -
SQL is hard (tags #SQLServer #dbadmin)
Originally published at Ramblings from the Flip Side (Site under construction). You can comment here or there.
So I’m basking the laurels of solving a performance issue, transforming a 2 day+ ETL process into a 15 minute process, when the next Big Thing comes down the pipes at work. I have to add five new columns to a feed that I ( Read more... ) -
Kissing the Job Goodbye (tags #SQLServer #dbadmin)
Originally published at Ramblings from the Flip Side (Site under construction). You can comment here or there.
Today I want to talk about my job, the day job. As a Jack-of-All-Trades DBA, I am responsible for backups, security, production releases, data fixes, architecture, schema approvals, development (both T-SQL and BI), mentoring ( Read more... ) -
Full Time Earning, Full Time Living (tags #sfwapro #writing #dbadmin)
Originally published at Ramblings from the Flip Side (Site under construction). You can comment here or there.
You know you’ve made an impact when people start coming up to you asking where you’ve found your full time writing gigs.
It’s been an interesting roller coaster ride for me since 2004. From hearing an editor refer to me as a ( Read more... ) -
SQL Saturdays - Searching for Definition (tags #sqlserver #dbadmin #tsql)
Originally published at Ramblings from the Flip Side (Site under construction). You can comment here or there.
To me, my SQL Saturdays posts aren’t just a method of information sharing or a way to teach new SQL Server database administrators. I also use it as a repository for my own purposes, recording bits of code or self-taught ( Read more... )